EMT Practice Test

1. Question Content...

---

Question1: Which two database objects can be created using fragmentation? (Choose two.)

Question2: What are two system level databases? (Choose two.)

Question3: Which command would you execute to restore to a specific moment-in-time?

Question4: What is the purpose of DB_LOCALE?

Question5: Which statement is used to create a permanent nonlogged table in a logged database?

Question6: Which two commands would create a table t1 with page level locking assuming default configuration parameter settings? (Choose two.)

Question7: Which of the following is true about star schemas?

Question8: Which two SQL commands can be used to invoke a stored procedure? (Choose two.)

Question9: You are about to create and load a table that will initially have a size of 50,000 KB. Once the table has been loaded, there will be very few additional inserts or updates to the table. When you create the table, which of the following extent size definitions would make the most effective use of disk space over time?

Question10: Which two installation modes are available for Informix? (Choose two.)

Question11: Under which of the following conditions does the LAST COMMITTED option have an effect on the COMMITTED READ isolation level?

Question12: Which document provides details on preparing an operating system to run Informix?

Question13: You received an error, "Chunk is not empty", while trying to remove a chunk. How do you verify which objects still occupy space in the chunk?

Question14: What is the default isolation level on a database with unbuffered logging?

Question15: What is the default isolation level on a mode ANSI database?

Question16: Which of the following utilities can be used for quick installation of pre-configured IBM Informix instances to many computers?

Question17: How does an administrator allocate a new dbspace from the storagepool?

Question18: Which two statements are true about the COMMIT WORK statement? (Choose two.)

Question19: Which of the following is true of system catalogs?

Question20: Which configuration parameters are used by ontape logical log backup?

Question21: In which way is a Remote Standalone (RS) secondary server different from a High-Availability Data Replication (HDR) secondary server?

Question22: Why would you want to create a table with a lock mode row as opposed to a lock mode page?

Question23: A DBA wants to know which commands have been executed through the SQL Admin API. What is the correct action?

Question24: There are two open sessions (session A and session B) that are updating the same tables. Session B is trying to read all rows in the table and is continuously receiving the error "-143 ISAM error: deadlock detected". Which action in session B would allow it to read all of the rows?

Question25: What is true about poll threads?

Question26: You create a table with the statement shown below: CREATE TABLE foo(col INTEGER) In which dbspace will the table reside?

Question27: Which database contains the system-monitoring interface (SMI) tables which provide information about the state of the database server?

Question28: What are the three major steps in implementing Label-Based Access Control (LBAC) in an instance environment? (Choose three.)

Question29: You want to use sqlhosts file /newlocation/newsqlhosts. Which of the following is true?

Question30: Which of the following is true about the remote query SELECT * FROM ABC@LMN:XYZ?

Question31: Which search condition is allowed in a check constraint?

Question32: In what way is Enterprise Replication (ER) replication different from High-Availability Cluster (HAC) replication?

Question33: Which technology can be used to execute Data Definition Language (DDL) command across multiple instances?

Question34: Enterprise Replication (ER) requires which data object to exist in all tables participating in replication?

Question35: Click the Exhibit button.

The tables shown in the exhibit have been created for a class enrollment system where a course can be assigned to many classes. The class table joins to the course table on the course_num columns. Which two of the following SQL statements are required to establish a referential integrity relationship between these tables? (Choose two.)

Question36: Which of the following can be used to move the physical log?

Question37: In which database does Informix store the information when a new task is created in OpenAdmin Tool's Task Scheduler?

Question38: Which one of the following will generate a typical Decision Support System (DSS) type of workload?

Question39: Which configuration parameter allows you to reduce the dependency on local OS user accounts and to enable a DBSA to grant database server access to specific users without the OS user accounts?

Question40: Which of the following Informix server modes disable execution of SQL statements for all users while allowing administrative users to perform maintenance tasks?

Question41: Which of the following is true about system catalog tables access?

Question42: Which two tasks can be accomplished using the OpenAdmin Tool (OAT)? (Choose two.)

Question43: Adding a row to which one of the following tables is required to create a database scheduler job?

Question44: Given the following table definition: CREATE TABLE t1(col1 BOOLEAN); Which of the following statements will fail to insert a row?

Question45: Which document describes new Informix features?

Question46: Which one of the following is a characteristic of a Decision Support System (DSS) or Data Warehousing environment?

Question47: Which two operations are performed with the onspaces command? (Choose two.)

Question48: Click the Exhibit button.

In the exhibit, which statement is true regarding the update statement of Client 2 if both of the clients are connected to the same logged database?

Question49: What functionality is exclusive to ontape (i.e. not present in onbar)?

Question50: Which of the following statements can be used to prevent duplicate values in an indexed column?

Question51: Which of the following statement is true of System Monitoring Interface (SMI) tables?

Question52: Which utility can be used to relocate the physical log to a new dbspace?

Question53: Click the Exhibit button.

An administrator created a table using the SQL statement shown in the exhibit to perform a load operation every day at 11:00 AM. What is the best way to optimize a backup strategy to recover the client table in case of a failure?

Question54: Which statement will change the column address1 to a null value?

Question55: Which Informix data movement utilities listed below can be used to move database from a computer running Windows operating system to an Apple computer?

Question56: Informix is currently in online mode. As a DataBase System Administrator (DBSA), you switch to administration mode with ADMIN_USER_MODE_WITH_DBSA = 0. Who can access Informix databases?

Question57: What functionality is exclusive to onbar (i.e. not present in ontape)?

Question58: Which authentication functionality allows you to implement different authentication mechanisms for different applications?

Question59: Which of the following methods can be used to transfer data in EXPRESS mode?

Question60: Which of the following modes is NOT supported by Informix?

Question61: Which two of the following are required for creating a dbspace? (Choose two.)

Question62: What is the only isolation level available on an unlogged database?

Question63: Which table type is always nonlogging?

Question64: Which one of the following is most suitable for scheduling the periodic collection of data about an instance?

Question65: Which of the following can be used in a SELECT statement to set one or more qualifying conditions to a group of records after they are formed?

Question66: Which of the following environment variables allow an application to specify formatting of locale-sensitive data such as of date and currency values?

Question67: Which phase of Fast Recovery rolls forward (restores) all transactions since the last checkpoint and rolls back any uncommitted transactions?

Question68: Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?

Question69: Which command listed below can be used to change the state of an operating Informix server?

Question70: Which statement can be used to roll back SQL statements within a transaction?

Question71: A progammer wants to unload a table to a file inside a stored procedure. What functionality listed below will help the programmer accomplish the task?

Question72: Which command would you execute to restore an instance without using or restoring the logical logs?

Question73: How can you determine which databases are created in an instance?

Question74: From the items listed below, what is the smallest granularity of item which may be restored?

Question75: Which two SQL API commands can be used to create a 10 MB dbspace? (Choose two.)

Question76: Click the Exhibit button.

Which of the following will display the values in the lead_time column from highest to lowest?

Question77: Which two statements will update all rows in the customer table? (Choose two.)

Question78: When storing string "ABCD" in a column, which of the following data types will result in a string stored with
2 padded spaces?

Question79: Which one of the following is most suitable for scheduling administrative functions that need to be performed periodically?

Question80: Given INFORMIXCONTIME = 60 and INFORMIXCONRETRY = 3, if the initial connection attempt fails, what subsequent attempts will be made to connect?

Question81: Which of these commands will create a table containing a column that will be automatically populated with a numeric value starting from an initial value of 2301 and incremented as rows are inserted?

Question82: Click the Exhibit button.

The query.sql file contains the information shown in the exhibit. The following command is run: dbaccess?
query.sql
How many rows will be returned by the select query?

Question83: When installing Informix, which two installation methods can be used? (Choose two.)

Question84: Which of the following statements is true about referential integrity?

Question85: Which two statements will delete all rows from table_name? (Choose two.)

Question86: What Informix data type is suitable for storing video clips up to a size of 4 TB?

Question87: Which two storage objects exist in Informix? (Choose two.)

Question88: Which isolation level is appropriate if you do not want your query to place any locks?

Question89: You have a database server environment where all databases use buffered logging. In which two conditions are the logical-log buffers in shared memory flushed to the logical log on disk? (Choose two.)

Question90: Assuming the tables and columns mentioned below exist, which of the following SQL statements will return an error?

Question91: When encountering an assertion failure or performance issue, which Informix utility, when run by the DBA, collects and bundles the basic diagnostic data?

Question92: Which command can be executed against a view?

Question93: Which of the following statement is correct about Shared Disk (SD) secondary servers?

Question94: Which of the following privileges can NOT be granted to a role?

Question95: What is the lowest level of granularity supported by Enterprise Replication?

Question96: Which two statements about oninit are correct? (Choose two.)

Question97: Given the query shown below:

What will happen?

Question98: In which two places may a function be used in a SELECT statement? (Choose two.)

Question99: Which utility would you use to print out the physical layout of the instance?

Question100: Business rules require that every time a row in table A is updated in your OLTP database, a row in table B must also be updated. How can you guarantee this rule will be maintained correctly and consistently when there are multiple applications and developers?

Question101: Which of the following methods will allow you to determine how much space is currently in use?

Question102: Which keyword is used to determine whether a comparison is true for every value returned from a subquery?

Question103: Click the Exhibit button.

In the exhibit, which ALTER TABLE statement is used to add the foreign key constraint where customer_num column in the orders table is a foreign key that references the customer_num column in the customer table?

Question104: User A creates a User Defined Routine (UDR). Which privilege must be granted to other users before they can run user A's UDR?

Question105: Click the Exhibit button.

In the exhibit, which two statements are correct? (Choose two.)

Question106: What is the minimum database-level privilege required for a user to create Stored Procedure Language routines?

Question107: Which two column definitions can store whole numbers from -(2^63-1) to (2^63-1)? (Choose two.)

Question108: Which command could be used to display the definition of user-defined and complex data types?

Question109: Which two events can initiate a trigger on a table? (Choose two.)

Question110: When you execute an INSERT statement, the database server will insert a NULL value into any column that meets which two conditions? (Choose two.)

Question111: What does the dbschema -ss option explicitly show besides lock mode, fragmentation strategy, and dbspace name?

Question112: Which command option should be used to resume an interrupted onbar restore?

Question113: Which two statements cause Stored Procedure Language (SPL) routine optimization? (Choose two.)

Question114: When restoring data, which granularity of object may NOT be restored?

Question115: Which two products can be used by client applications to connect to Informix instances? (Choose two.)

Question116: Given the following: CREATE TABLE customer (customer_num INT, company CHAR(25)); Which of the following SQL statements will return an error?

Question117: Which of the following is required for a cold restore?

Question118: What are two ways to create table t1 with row level locking? (Choose two.)

Question119: Which of the following utilities can be used for quick installation of pre-configured IBM Informix instances to many computers?

Question120: Which of the following can be used to create and drop logical logs?